package com.javasm.finance.dao;

import com.javasm.finance.entity.ProdChannel;
import com.javasm.finance.entity.ProductCategory;
import com.javasm.finance.entity.User;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface ProductCategoryDao {

    //获取产品系列详细信息
    List<ProductCategory> queryProductCategory(Integer page, Integer pageSize, String prodName) throws SQLException;

    long findTotalNum(String prodName) throws SQLException;

    int addProductCategory(ProductCategory productCategory) throws SQLException;

    ProductCategory findByPid(Integer prodId) throws SQLException;

    int editProd(ProductCategory productCategory) throws SQLException;

    List<ProdChannel> queryChannel() throws SQLException;

    ProductCategory findByPidRemi(Integer prodId) throws SQLException;

    int addRemi(ProductCategory productCategory) throws SQLException;

    int deleteProd(Integer prodId) throws SQLException;
}
